Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | RetailTransactionLineItemGroup(TR_RTL_LTMGP) |
LineItemGroupID (FK)(PK) | The unique identifier for this LineItemGroup within the bounds of the parent RetailTransaction. | ID_TRN_LTMGP | LineNumber | smallint | RetailTransactionLineItemGroup(TR_RTL_LTMGP) |
TransactionTotalTypeCode (FK)(PK) | A unique assigned mnemonic identifier that identifies the TransactionTotalType | TY_TRN_TOT | Code | varchar(20) | TransactionTotalType(TR_TOT_TYP) |
SubtotalAmount | The monetary value of the transaction line item subtotal group. | MO_TOT | Money | decimal(16,5) | |